Move Tables to different tablespace - Oracle DBA Forums ... I have this sql to generate alter statement to move tables from one tablespace to another. SELECT 'ALTER TABLE ' || OBJECT_NAME ||' MOVE ...